FINESSE: a financial information spreadsheet
نویسندگان
چکیده
We outline a spreadsheet-based system for visualization of real-time financial information. Our system permits the user to define arithmetic and presentation relationships amongst the various cells of the spreadsheet. The cells contain primitives that can be numbers, text, images, functions, and graphics. Presenting financial information in this format allows its intended clients, the financial analysts, to work in the fgmiliar environment of a spreadsheet and allows them the flexibility afforded by the powerful interface of the spreadsheet paradigm. In addition, our system permits real-time visualization of the financial data stream allowing its user to visually track the changing market trends in two and three dimensions.
منابع مشابه
NLP-SIR: A Natural Language Approach for Spreadsheet Information Retrieval
Spreadsheets are a ubiquitous software tool, used for a wide variety of tasks such as financial modelling, statistical analysis and inventory management. Extracting meaningful information from such data can be a difficult task, especially for novice users unfamiliar with the advanced data processing features of many spreadsheet applications. We believe that through the use of Natural Language P...
متن کاملEvaluating Financial Model Performance: An Empirical Analysis of Some North Sea Investments
Fifty North Sea oil & gas investment transactions were analysed using traditional spreadsheet based financial modelling methods. The purpose of the analysis was to determine if there was a statistically significant relationship between the price paid for an oil & gas asset and the actual or expected financial return over the asset’s economically useful life. Several interesting and statisticall...
متن کاملBridging the Gap between Spreadsheet Use and Control: An Instructional Case
ABSTRACT: End user applications (such as spreadsheets) have been cited as a previously ignored yet potentially significant risk to financial reporting in the wake of The Sarbanes-Oxley Act (PricewaterhouseCoopers [PwC] 2004; Ernst&Young [E&Y] 2004). We developed a realistic spreadsheet model in order to expose students to internal control issues inherent in a spreadsheet environment. By complet...
متن کاملMultiple Foci Drill-Down through Tuple and Attribute Polyarchies in Tabular Data
Information analysis often involves decomposing data into sub-groups to allow for comparison and identification of relationships. Breakdown Visualization provides a mechanism to support this analysis through user guided drill-down of polyarchical metadata. This metadata describes multiple hierarchical structures for organizing tuple aggregation and table attributes. This structure is seen in sp...
متن کاملTesting spreadsheet accuracy theory
Electronic spreadsheets are used extensively to support financial analysis and problem solving processes; however, research has revealed that experienced professionals and students make many errors when developing spreadsheets. Practitioners recognize the importance of accuracy and have published many techniques for improving the accuracy of their spreadsheets. Their prescriptions and results o...
متن کامل